SELECT "school"."!",
       "school"."code",
       "school"."name",
       "school"."campus",
       "department"."code",
       "department"."name",
       "department"."school_code"
FROM "department"
     LEFT OUTER JOIN (SELECT 1 AS "!",
                             "school"."code",
                             "school"."name",
                             "school"."campus"
                      FROM "school") AS "school"
                     ON ("department"."school_code" = "school"."code")
ORDER BY 5 ASC
LIMIT 10000